/*
 Navicat Premium Data Transfer

 Source Server         : 115.190.73.103
 Source Server Type    : MySQL
 Source Server Version : 90100 (9.1.0)
 Source Host           : 115.190.73.103:3306
 Source Schema         : hongshu_nacos_config

 Target Server Type    : MySQL
 Target Server Version : 90100 (9.1.0)
 File Encoding         : 65001

 Date: 23/10/2025 14:19:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config_info
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `c_use` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `effect` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `type` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `c_schema` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `encrypted_data_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT '秘钥',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='config_info';

-- ----------------------------
-- Records of config_info
-- ----------------------------
BEGIN;
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (10, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n  autoconfigure:\n    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n  mvc:\n    pathmatch:\n      matching-strategy: ant_path_matcher\n\n# feign 配置\nfeign:\n  sentinel:\n    enabled: true\n  okhttp:\n    enabled: true\n  httpclient:\n    enabled: false\n  client:\n    config:\n      default:\n        connectTimeout: 10000\n        readTimeout: 10000\n  compression:\n    request:\n      enabled: true\n      min-request-size: 8192\n    response:\n      enabled: true\n\n# 暴露监控端点\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n', '58dde4e3760499d3bac2d77a3a1e9018', '2025-01-09 17:22:59', '2025-01-09 17:22:59', '', '120.245.102.233', '', '', NULL, NULL, NULL, 'yaml', NULL, '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (11, 'hongshu-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n  redis:\n    host: 115.190.73.103\n    port: 6379\n    password: Myj950501\n  cloud:\n    gateway:\n      discovery:\n        locator:\n          lowerCaseServiceId: true\n          enabled: true\n      routes:\n        # 认证中心\n        - id: hongshu-auth\n          uri: lb://hongshu-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            # 验证码处理\n            - CacheRequestFilter\n            - ValidateCodeFilter\n            - StripPrefix=1\n        # 代码生成\n        - id: hongshu-gen\n          uri: lb://hongshu-gen\n          predicates:\n            - Path=/code/**\n          filters:\n            - StripPrefix=1\n        # 定时任务\n        - id: hongshu-job\n          uri: lb://hongshu-job\n          predicates:\n            - Path=/schedule/**\n          filters:\n            - StripPrefix=1\n        # 系统模块\n        - id: hongshu-system\n          uri: lb://hongshu-system\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n        # 文件服务\n        - id: hongshu-file\n          uri: lb://hongshu-file\n          predicates:\n            - Path=/file/**\n          filters:\n            - StripPrefix=1\n        # 静态资源：本地文件访问\n        - id: hongshu-file-static\n          uri: lb://hongshu-file\n          predicates:\n            - Path=/profile/**\n        # web服务\n        - id: hongshu-web\n          uri: lb://hongshu-web\n          predicates:\n            - Path=/web/**\n          filters:\n            - StripPrefix=1\n        # idle服务\n        - id: hongshu-idle\n          uri: lb://hongshu-idle\n          predicates:\n            - Path=/idle/**\n          filters:\n            - StripPrefix=1\n        # chat服务\n        - id: hongshu-chat\n          uri: lb://hongshu-chat\n          predicates:\n            - Path=/chat/**\n          filters:\n            - StripPrefix=1\n\n\n# 安全配置\nsecurity:\n  # 验证码\n  captcha:\n    enabled: true\n    type: math\n  # 防止XSS攻击\n  xss:\n    enabled: true\n    excludeUrls:\n      - /system/notice\n  # 不校验白名单\n  ignore:\n    whites:\n      - /auth/logout\n      - /auth/login\n      - /auth/register\n      - /*/v2/api-docs\n      - /csrf\n      - /web/**\n      - /idle/**\n      - /chat/**\n      - /*/v2/api-docs\n      - /*/v3/api-docs\n\n# springdoc配置\nspringdoc:\n  webjars:\n    # 访问前缀\n    prefix:\n', 'a4b3c2929ec49982137b215a71b7c1d3', '2025-01-09 17:22:59', '2025-10-12 10:53:53', NULL, '221.3.19.207', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (12, 'hongshu-auth-dev.yml', 'DEFAULT_GROUP', 'spring:\n  redis:\n    host: 115.190.73.103\n    port: 6379\n    password: Myj950501\n\n# springdoc配置\nspringdoc:\n  gatewayUrl: http://115.190.73.103:8080/${spring.application.name}\n  api-docs:\n    # 是否开启接口文档\n    enabled: true\n  info:\n    # 标题\n    title: \'认证授权模块接口文档\'\n    # 描述\n    description: \'认证授权模块接口描述\'\n    # 作者信息\n    contact:\n      name: hongshu\n      url: https://ruoyi.vip', 'ef8ddd87a9e2945af571e2eb5b9e231b', '2025-01-09 17:22:59', '2025-07-22 15:28:42', NULL, '221.0.131.144', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (13, 'hongshu-monitor-dev.yml', 'DEFAULT_GROUP', '# spring\nspring:\n  security:\n    user:\n      name: root\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 红薯服务状态监控\n', '516868766c303cd9673f4fee5fd8f42b', '2025-01-09 17:22:59', '2025-01-09 17:22:59', '', '120.245.102.233', '', '', NULL, NULL, NULL, 'yaml', NULL, '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (14, 'hongshu-system-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n  redis:\n    host: 115.190.73.103\n    port: 6379\n    password: Myj950501\n    \n  datasource:\n    druid:\n      stat-view-servlet:\n        enabled: true\n        loginUsername: admin\n        loginPassword: 123456\n    dynamic:\n      druid:\n        initial-size: 5\n        min-idle: 5\n        maxActive: 20\n        maxWait: 60000\n        connectTimeout: 30000\n        socketTimeout: 60000\n        timeBetweenEvictionRunsMillis: 60000\n        minEvictableIdleTimeMillis: 300000\n        validationQuery: SELECT 1 FROM DUAL\n        testWhileIdle: true\n        testOnBorrow: false\n        testOnReturn: false\n        poolPreparedStatements: true\n        maxPoolPreparedStatementPerConnectionSize: 20\n        filters: stat,slf4j\n        connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n      datasource:\n          # 主库数据源\n          master:\n            driver-class-name: com.mysql.cj.jdbc.Driver\n            url: jdbc:mysql://115.190.73.103:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n            username: root\n            password: Myj950501\n          # 从库数据源\n          # slave:\n            # username: \n            # password: \n            # url: \n            # driver-class-name: \n\n#mybatis-plus\nmybatis-plus:\n  #实体扫描，多个package用逗号或者分号分隔\n  typeAliasesPackage: com.hongshu.system\n  mapperLocations: classpath:mapper/**/*.xml\n  global-config:\n    #数据库相关配置\n    db-config:\n      #主键类型  AUTO:\"数据库ID自增\", INPUT:\"用户输入ID\", ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n      id-type: AUTO\n      logic-delete-value: -1\n      logic-not-delete-value: 0\n\n# springdoc配置\nspringdoc:\n  gatewayUrl: http://115.190.73.103:8080/${spring.application.name}\n  api-docs:\n    # 是否开启接口文档\n    enabled: true\n  info:\n    # 标题\n    title: \'系统模块接口文档\'\n    # 描述\n    description: \'系统模块接口描述\'\n    # 作者信息\n    contact:\n      name: hongshu\n      url: https://ruoyi.vip', 'ead4cec18aec2cdf8fd072b8f2e30bcf', '2025-01-09 17:22:59', '2025-07-22 15:44:35', NULL, '221.0.131.144', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (15, 'hongshu-job-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n  redis:\n    host: 115.190.73.103\n    port: 6379\n    password: Myj950501\n    \n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://115.190.73.103:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: Myj950501\n\n#mybatis-plus\nmybatis-plus:\n  #实体扫描，多个package用逗号或者分号分隔\n  typeAliasesPackage: com.hongshu.job\n  mapperLocations: classpath:mapper/**/*.xml\n  global-config:\n    #数据库相关配置\n    db-config:\n      #主键类型  AUTO:\"数据库ID自增\", INPUT:\"用户输入ID\", ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n      id-type: AUTO\n      logic-delete-value: -1\n      logic-not-delete-value: 0\n\n# springdoc配置\nspringdoc:\n  gatewayUrl: http://115.190.73.103:8080/${spring.application.name}\n  api-docs:\n    # 是否开启接口文档\n    enabled: true\n  info:\n    # 标题\n    title: \'定时任务接口文档\'\n    # 描述\n    description: \'定时任务接口描述\'\n    # 作者信息\n    contact:\n      name: hongshu\n      url: ', '87c5f267e057eeb58ef156ffb60c9ac8', '2025-01-09 17:22:59', '2025-07-22 15:45:14', NULL, '221.0.131.144', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (16, 'hongshu-file-dev.yml', 'DEFAULT_GROUP', '# # 本地文件上传    \n# file:\n#     domain: http://127.0.0.1:9300\n#     path: /Users/mayongjian/Desktop/hongshu_cloud/springcloud_hongshu/upload\n#     prefix: /profile\n\n# # FastDFS配置\n# fdfs:\n#   domain: http://8.129.231.12\n#   soTimeout: 3000\n#   connectTimeout: 2000\n#   trackerList: 8.129.231.12:22122\n\n# # Minio配置\n# minio:\n#   url: http://8.129.231.12:9000\n#   accessKey: minioadmin\n#   secretKey: minioadmin\n#   bucketName: test\n\n# # 七牛云配置\n# qiniuyun:\n#   domain: https://image.mayongjian.cn\n#   accessKey: DtBEKv-uwl79DhgdGRWDTxX0qrVw2oLb25BuNpTv\n#   secretKey: JV6AM6iMR6ovouNEwoSQvLpsRWLhwOjBmnj2SyxP\n#   bucketName: xiaomage-blog\n\n# # 腾讯云COS配置\n# tencent:\n#   domain: https://cos.yourcdn.com\n#   secretId: xxx\n#   secretKey: xxx\n#   region: ap-shanghai\n#   bucketName: your-bucket-123456\n#   pathPrefix: upload\n\n# # 阿里云OSS配置\n# aliyun:\n#   domain: https://img.yourcdn.com\n#   endpoint: oss-cn-shanghai.aliyuncs.com\n#   accessKeyId: xxx\n#   accessKeySecret: xxx\n#   bucketName: your-bucket\n#   pathPrefix: upload\n\n\n# spring配置\nspring:\n  redis:\n    host: localhost\n    port: 6379\n    password: Myj950501\n    \n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://localhost:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: Myj950501\n\n#mybatis-plus\nmybatis-plus:\n  #实体扫描，多个package用逗号或者分号分隔\n  typeAliasesPackage: com.hongshu.job\n  mapperLocations: classpath:mapper/**/*.xml\n  global-config:\n    #数据库相关配置\n    db-config:\n      #主键类型  AUTO:\"数据库ID自增\", INPUT:\"用户输入ID\", ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n      id-type: AUTO\n      logic-delete-value: -1\n      logic-not-delete-value: 0', '6c78eff6ccf36b971a022c01c3c54c72', '2025-01-09 17:22:59', '2025-09-19 14:43:40', NULL, '221.3.19.207', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (17, 'sentinel-hongshu-gateway', 'DEFAULT_GROUP', '[\n    {\n        \"resource\": \"jingjie-auth\",\n        \"count\": 500,\n        \"grade\": 1,\n        \"limitApp\": \"default\",\n        \"strategy\": 0,\n        \"controlBehavior\": 0\n    },\n	{\n        \"resource\": \"jingjie-system\",\n        \"count\": 1000,\n        \"grade\": 1,\n        \"limitApp\": \"default\",\n        \"strategy\": 0,\n        \"controlBehavior\": 0\n    },\n	{\n        \"resource\": \"jingjie-gen\",\n        \"count\": 200,\n        \"grade\": 1,\n        \"limitApp\": \"default\",\n        \"strategy\": 0,\n        \"controlBehavior\": 0\n    },\n	{\n        \"resource\": \"jingjie-job\",\n        \"count\": 300,\n        \"grade\": 1,\n        \"limitApp\": \"default\",\n        \"strategy\": 0,\n        \"controlBehavior\": 0\n    }\n]', '142e85d393378daa30eba08e427997d5', '2025-01-09 17:22:59', '2025-01-09 17:22:59', '', '120.245.102.233', '', '', NULL, NULL, NULL, 'text', NULL, '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (18, 'hongshu-web-dev.yml', 'DEFAULT_GROUP', '# 项目相关配置\nhongshu:\n  # 名称\n  name: hongshu\n  # 版本\n  version: 1.0\n  # 版权年份\n  copyrightYear: 2024\n  # 文件路径 示例（ Windows配置D:/hongshu/uploadPath，Linux配置 /home/hongshu/uploadPath）\n  profile: D:/hongshu/uploadPath\n  # 获取ip地址开关\n  addressEnabled: false\n  # 验证码类型 math 数字计算 char 字符验证\n  captchaType: math\n\n# 开发环境配置\nserver:\n  # 服务器的HTTP端口，默认为8080\n  port: 9002\n  servlet:\n    # 应用的访问路径\n    context-path: /\n  tomcat:\n    # tomcat的URI编码\n    uri-encoding: UTF-8\n    # 连接数满后的排队数，默认为100\n    accept-count: 1000\n    threads:\n      # tomcat最大线程数，默认为200\n      max: 800\n      # Tomcat启动初始化的线程数，默认值10\n      min-spare: 100\n\n# 日志配置\nlogging:\n  level:\n    com.jingjie: debug\n    org.springframework: warn\n\n# 用户配置\nuser:\n  password:\n    # 密码最大错误次数\n    maxRetryCount: 5\n    # 密码锁定时间（默认10分钟）\n    lockTime: 10\n\n# Spring配置\nspring:\n  # 资源信息\n  messages:\n    # 国际化资源文件路径\n    basename: i18n/messages\n  profiles:\n    active: druid\n  # 文件上传\n  servlet:\n    multipart:\n      # 单个文件大小\n      max-file-size: 10MB\n      # 设置总上传的文件大小\n      max-request-size: 20MB\n  # 服务模块\n  devtools:\n    restart:\n      # 热部署开关\n      enabled: true\n  # redis 配置\n  redis:\n    # 地址\n    host: 115.190.73.103\n    # 端口，默认为6379\n    port: 6379\n    # 数据库索引\n    database: 0\n    # 密码\n    password: Myj950501\n    # 连接超时时间\n    timeout: 10s\n    lettuce:\n      pool:\n        # 连接池中的最小空闲连接\n        min-idle: 0\n        # 连接池中的最大空闲连接\n        max-idle: 8\n        # 连接池的最大数据库连接数\n        max-active: 8\n        # #连接池最大阻塞等待时间（使用负值表示没有限制）\n        max-wait: -1ms\n  \n  datasource:\n    druid:\n      stat-view-servlet:\n        enabled: true\n        loginUsername: admin\n        loginPassword: 123456\n    dynamic:\n      druid:\n        initial-size: 5\n        min-idle: 5\n        maxActive: 20\n        maxWait: 60000\n        connectTimeout: 30000\n        socketTimeout: 60000\n        timeBetweenEvictionRunsMillis: 60000\n        minEvictableIdleTimeMillis: 300000\n        validationQuery: SELECT 1 FROM DUAL\n        testWhileIdle: true\n        testOnBorrow: false\n        testOnReturn: false\n        poolPreparedStatements: true\n        maxPoolPreparedStatementPerConnectionSize: 20\n        filters: stat,slf4j\n        connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n      datasource:\n          # 主库数据源\n          master:\n            driver-class-name: com.mysql.cj.jdbc.Driver\n            url: jdbc:mysql://115.190.73.103:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n            username: root\n            password: Myj950501\n          # 从库数据源\n          # slave:\n            # username: \n            # password: \n            # url: \n            # driver-class-name: \n# token配置\ntoken:\n  # 令牌自定义标识\n  header: Authorization\n  # 令牌密钥\n  secret: abcdefghijklmnopqrstuvwxyz\n  # 令牌有效期（默认30分钟）\n  expireTime: 30\n\n#mybatis-plus\nmybatis-plus:\n  #实体扫描，多个package用逗号或者分号分隔\n  typeAliasesPackage: com.hongshu.web\n  mapperLocations: classpath:mapper/**/*.xml\n  global-config:\n    #数据库相关配置\n    db-config:\n      #主键类型  AUTO:\"数据库ID自增\", INPUT:\"用户输入ID\", ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n      id-type: AUTO\n      logic-delete-value: -1\n      logic-not-delete-value: 0\n\n# PageHelper分页插件\npagehelper:\n  helperDialect: mysql\n  supportMethodsArguments: true\n  params: count=countSql\n\n# springdoc配置\nspringdoc:\n  gatewayUrl: http://115.190.73.103:8080/${spring.application.name}\n  api-docs:\n    # 是否开启接口文档\n    enabled: true\n  info:\n    # 标题\n    title: \'代码生成接口文档\'\n    # 描述\n    description: \'代码生成接口描述\'\n    # 作者信息\n    contact:\n      name: hongshu\n      url: \n\n# 防止XSS攻击\nxss:\n  # 过滤开关\n  enabled: true\n  # 排除链接（多个用逗号分隔）\n  excludes: /system/notice\n  # 匹配链接\n  urlPatterns: /system/*,/monitor/*,/tool/*\n\nes:\n  url: 115.190.73.103\n  port: 9200\n  username:\n  password:\n\n# 短信配置 aliyun、tencent、yunpian\nsms:\n  primary: aliyun\n  secondary: yunpian\n  aliyun:\n    key: LTAI5tKNw3nGB26WxYA7mSkS\n    secret: 4eSz4WFSnSXR8tXp0k7nwXNx431VKB\n    sign-name: 小马哥博客\n    template-code: SMS_463602389\n  tencent:\n    secret-id:\n    secret-key:\n    sdk-app-id:\n    sign-name:\n    template-id:\n    region:\n  yunpian:\n    apikey: 051af63e4a70bfde935be0562c0089e3\n    sign-name: 红薯\n\n# 高德地图配置\namap:\n  key: b446dc0039d7dc0e7593a70691dbe5b1\n  security-key:\n\n# Oss存储配置 0:本地 1:七牛云 2:Minio 3:腾讯云 4：阿里云\noss:\n  type: 1\n  # 七牛云配置\n  qiniuyun:\n    domain: https://image.mayongjian.cn\n    accessKey: DtBEKv-uwl79DhgdGRWDTxX0qrVw2oLb25BuNpTv\n    secretKey: JV6AM6iMR6ovouNEwoSQvLpsRWLhwOjBmnj2SyxP\n    bucketName: xiaomage-blog\n  # Minio配置\n  minio:\n    url: http://8.129.231.12:9000\n    accessKey: minioadmin\n    secretKey: minioadmin\n    bucketName: test\n  # 腾讯云配置\n  tencent:\n    bucketName:\n    endpoint:\n    ossKeyId:\n    ossKeySecret:\n  # 阿里云配置\n  aliyun:\n    bucketName:\n    endpoint:\n    accessKeyId:\n    accessKeySecret:\n\nfile:\n  upload:\n    path: /data/docker/nginx/html/data\n\nalipay:\n  pid: 2088721062044222\n  appId: 2021000146676140\n  merchantPrivateKey: MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCSs1MTjHfpVThFRY8t1Q5yeP4talcJJ6YXlELWA4PpOWOvj1fYahUgnX8ToIEj2SalgDem39g//fNZF01eYgJACQLJ/BVuVyhScgdQq5akjY7j3kd5E/p1TINQiqf7lr0oWlIb/36ibENXjsVtB+C+xWUpfAl5yhtnr3X/NLwgJrdr54wEIhZASUq+1EhSynF6egw9FTtwA37/cCIzgeSR8CLrF9sv3UIC74KtmV++30rb3MiHPNhECiIydUdc159IuNGWxg417Sdveifea7D5cf7FUj4LhPIGbn1wECJp/t/CB0HWyZXAG0mX981eJLD29P59o8GGa6CErgBf3HmTAgMBAAECggEASBYuYJDJ67KgsAl6Tf8/1ih2XkK++hStnTCRlzCrBVPaFE7Pz9xw/VHnO/HHA6KVRwY2Up30WZ2kksbMkfB/QpAq+q4QqePSQJEf3xgyMjINYRO881ZJ4JH0hQNdgFeWI9oeNvvZcl7YyJGzmdwhKB0/lJ8K2PnjdZPW281CFFmzjEaAxcS9zU3hsCX3ByyRlRv2NVlwfqOCjhhdApAuiRr1cT7nnZmciJgytqAsQM2QgoYWBIHFqjjGS/g8kSsyehqd89DpPOcj/khBSBVgofKNVd26MYIl6nh1ZVXg/nKKiNQ3i75mCgCcfOG9Mi75J5Ru4Cm5fa9bgxyRmaIG4QKBgQDGqeeC7qtkwDPbm5VK+bAWSOKTwW+Xm+02J1ePCgFwtE/DKGj5n5+8LYvuOHYMscwD3DZaRx9h9W4F0VfXUPAIs4kw+EOX2zWEaM30iWXJlVz9rb/j5wAikVKVZbhsP5O2updljOwV1Qs1YskMBRrHuKvCjNVI2YojuCf+MciMDQKBgQC9CinneNFyPT+S1HSC0vQQ9yrzr+SNWN9cc0Z/TB6ahWCJYaq1dOKIpV6HlsnS7plbKExYOeJt2VqSkGCe//uHJpYcEZfSXH62aT4Gv+eIIbIe0bhx3pgFQOkos6tBoENXnfmqv6ijbr8CAgDKqj9mP/2RoS5sJuFZzWGgcwyUHwKBgQCOK0DWXl6hdzqlSi4Iva7aA8bB3ogxgxC61GTApHRrZ149V0noeeciD6Y4EIfKheJuUMVEzekTfUQDPdES8YUVdQYU2VXl8qXV3/qjqUAChrVJhXHxcnqSQlVLPMRCEy1ucxGtRrAc351p0wv1YiHME8g3LfnkbGmDLmLQcmgGcQKBgQCYU31KuO9Et5fnr+ymkmf618AzltN7Flb9vyHaZ7LtXnZYnWuaRjJYW7DdXyMIJh1K+CD0osgTLiaunUpONQUwdWZV/dMxvjiYshs6Ax8Fcel+rg2LLAuhiBmZI5XnDsXU70YEUeYIs6+UZZrPs/ncYcnotFGc8oN6AmYdjTdgjwKBgQCdqEp99qzqB8H+/lxpHar2K6bc6Ezmw44sOrlzvBPwg4MZFsNpje8SsEneIeDgZ03DhdaeiD4OkD4mr9JXUYsdiCRgIuDAV2/QsJJbHetchnU3SfT5g76Yc9iuAZNoTNTRdyJlemNQGBuRnIacvxuCPRh2Zr40710Ad82Q1x49qg==\n  alipayPublicKey: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAuYvIn8dC0AR299bvCnhV1on73/aSwGbm3PMxlc8AjmdWlT94g/4Mb6Oyc2Mf0lZj6N4o//w2z2pdUrXXlctLkaHoRjd3VMTYL+5gNc9iBueJt+/+TSjPMiU274csDJZhLrwVMuwccv1GdzvT3TQq1o709qrcZMMo+rELDcOHJmX7ikYMzEEHMeRI6xPKSDNswdYMSsutgIqxvJKs3chQPgMWvsBzgIHFfLolGtgTr4fi9zGuk2qSxBY0HfzTZyMACr8IXxw8lgNV3YB5djFLms5uY1qSlrvrODGWQgCsTxEGmNZAaZZQiboFaLPbZ/rsHFAGoy7qsAbYBmYoWwbmGwIDAQAB\n  notifyUrl: http://115.190.73.103/api/alipay/notify\n  returnUrl: http://115.190.73.103/idle\n  signType: RSA2\n  charset: UTF-8\n  # 我的支付宝网关地址\n  gatewayUrl: https://openapi-sandbox.dl.alipaydev.com/gateway.do\n\n# 滑块验证码\naj:\n  captcha:\n    # 缓存类型\n    cache-type: redis\n    # blockPuzzle 滑块 clickWord 文字点选  default默认两者都实例化\n    type: blockPuzzle\n    # 右下角显示字\n    water-mark: 红薯\n    # 校验滑动拼图允许误差偏移量(默认5像素)\n    slip-offset: 5\n    # aes加密坐标开启或者禁用(true|false)\n    aes-status: true\n    # 滑动干扰项(0/1/2)\n    interference-options: 2\n    # 滑动图片\n    jigsaw: classpath:images/jigsaw\n    # 点击图片\n    pic-click: classpath:images/pic-click', '79b3a1f24d8d4416eff58e9d8d956bfb', '2025-01-09 17:22:59', '2025-07-22 15:31:07', NULL, '221.0.131.144', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (21, 'hongshu-idle-dev.yml', 'DEFAULT_GROUP', '\n# Spring配置\nspring:\n  # 资源信息\n  messages:\n    # 国际化资源文件路径\n    basename: i18n/messages\n  profiles:\n    active: druid\n  # 文件上传\n  servlet:\n    multipart:\n      # 单个文件大小\n      max-file-size: 10MB\n      # 设置总上传的文件大小\n      max-request-size: 20MB\n  # 服务模块\n  devtools:\n    restart:\n      # 热部署开关\n      enabled: true\n  # redis 配置\n  redis:\n    # 地址\n    host: 115.190.73.103\n    # 端口，默认为6379\n    port: 6379\n    # 数据库索引\n    database: 0\n    # 密码\n    password: Myj950501\n    # 连接超时时间\n    timeout: 10s\n    lettuce:\n      pool:\n        # 连接池中的最小空闲连接\n        min-idle: 0\n        # 连接池中的最大空闲连接\n        max-idle: 8\n        # 连接池的最大数据库连接数\n        max-active: 8\n        # #连接池最大阻塞等待时间（使用负值表示没有限制）\n        max-wait: -1ms\n  \n  datasource:\n    druid:\n      stat-view-servlet:\n        enabled: true\n        loginUsername: admin\n        loginPassword: 123456\n    dynamic:\n      druid:\n        initial-size: 5\n        min-idle: 5\n        maxActive: 20\n        maxWait: 60000\n        connectTimeout: 30000\n        socketTimeout: 60000\n        timeBetweenEvictionRunsMillis: 60000\n        minEvictableIdleTimeMillis: 300000\n        validationQuery: SELECT 1 FROM DUAL\n        testWhileIdle: true\n        testOnBorrow: false\n        testOnReturn: false\n        poolPreparedStatements: true\n        maxPoolPreparedStatementPerConnectionSize: 20\n        filters: stat,slf4j\n        connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n      datasource:\n          # 主库数据源\n          master:\n            driver-class-name: com.mysql.cj.jdbc.Driver\n            url: jdbc:mysql://115.190.73.103:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n            username: root\n            password: Myj950501\n          # 从库数据源\n          # slave:\n            # username: \n            # password: \n            # url: \n            # driver-class-name: \n# token配置\ntoken:\n  # 令牌自定义标识\n  header: Authorization\n  # 令牌密钥\n  secret: abcdefghijklmnopqrstuvwxyz\n  # 令牌有效期（默认30分钟）\n  expireTime: 30\n\n#mybatis-plus\nmybatis-plus:\n  #实体扫描，多个package用逗号或者分号分隔\n  typeAliasesPackage: com.hongshu.web\n  mapperLocations: classpath:mapper/**/*.xml\n  global-config:\n    #数据库相关配置\n    db-config:\n      #主键类型  AUTO:\"数据库ID自增\", INPUT:\"用户输入ID\", ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n      id-type: AUTO\n      logic-delete-value: -1\n      logic-not-delete-value: 0\n\n# PageHelper分页插件\npagehelper:\n  helperDialect: mysql\n  supportMethodsArguments: true\n  params: count=countSql\n\n# springdoc配置\nspringdoc:\n  gatewayUrl: http://115.190.73.103:8080/${spring.application.name}\n  api-docs:\n    # 是否开启接口文档\n    enabled: true\n  info:\n    # 标题\n    title: \'闲宝服务接口文档\'\n    # 描述\n    description: \'闲宝服务接口描述\'\n    # 作者信息\n    contact:\n      name: hongshu\n      url: \n\n# 防止XSS攻击\nxss:\n  # 过滤开关\n  enabled: true\n  # 排除链接（多个用逗号分隔）\n  excludes: /system/notice\n  # 匹配链接\n  urlPatterns: /system/*,/monitor/*,/tool/*\n\nes:\n  url: 115.190.73.103\n  port: 9200\n  username:\n  password:\n\n# Oss存储配置 0:本地 1:七牛云 2:Minio 3:腾讯云 4：阿里云\noss:\n  type: 1\n  # 七牛云配置\n  qiniuyun:\n    domain: https://image.mayongjian.cn\n    accessKey: DtBEKv-uwl79DhgdGRWDTxX0qrVw2oLb25BuNpTv\n    secretKey: JV6AM6iMR6ovouNEwoSQvLpsRWLhwOjBmnj2SyxP\n    bucketName: xiaomage-blog\n  # Minio配置\n  minio:\n    url: http://8.129.231.12:9000\n    accessKey: minioadmin\n    secretKey: minioadmin\n    bucketName: test\n  # 腾讯云配置\n  tencent:\n    bucketName:\n    endpoint:\n    ossKeyId:\n    ossKeySecret:\n  # 阿里云配置\n  aliyun:\n    bucketName:\n    endpoint:\n    accessKeyId:\n    accessKeySecret:\n\nalipay:\n  pid: 2088721062044222\n  appId: 2021000146676140\n  merchantPrivateKey: MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCSs1MTjHfpVThFRY8t1Q5yeP4talcJJ6YXlELWA4PpOWOvj1fYahUgnX8ToIEj2SalgDem39g//fNZF01eYgJACQLJ/BVuVyhScgdQq5akjY7j3kd5E/p1TINQiqf7lr0oWlIb/36ibENXjsVtB+C+xWUpfAl5yhtnr3X/NLwgJrdr54wEIhZASUq+1EhSynF6egw9FTtwA37/cCIzgeSR8CLrF9sv3UIC74KtmV++30rb3MiHPNhECiIydUdc159IuNGWxg417Sdveifea7D5cf7FUj4LhPIGbn1wECJp/t/CB0HWyZXAG0mX981eJLD29P59o8GGa6CErgBf3HmTAgMBAAECggEASBYuYJDJ67KgsAl6Tf8/1ih2XkK++hStnTCRlzCrBVPaFE7Pz9xw/VHnO/HHA6KVRwY2Up30WZ2kksbMkfB/QpAq+q4QqePSQJEf3xgyMjINYRO881ZJ4JH0hQNdgFeWI9oeNvvZcl7YyJGzmdwhKB0/lJ8K2PnjdZPW281CFFmzjEaAxcS9zU3hsCX3ByyRlRv2NVlwfqOCjhhdApAuiRr1cT7nnZmciJgytqAsQM2QgoYWBIHFqjjGS/g8kSsyehqd89DpPOcj/khBSBVgofKNVd26MYIl6nh1ZVXg/nKKiNQ3i75mCgCcfOG9Mi75J5Ru4Cm5fa9bgxyRmaIG4QKBgQDGqeeC7qtkwDPbm5VK+bAWSOKTwW+Xm+02J1ePCgFwtE/DKGj5n5+8LYvuOHYMscwD3DZaRx9h9W4F0VfXUPAIs4kw+EOX2zWEaM30iWXJlVz9rb/j5wAikVKVZbhsP5O2updljOwV1Qs1YskMBRrHuKvCjNVI2YojuCf+MciMDQKBgQC9CinneNFyPT+S1HSC0vQQ9yrzr+SNWN9cc0Z/TB6ahWCJYaq1dOKIpV6HlsnS7plbKExYOeJt2VqSkGCe//uHJpYcEZfSXH62aT4Gv+eIIbIe0bhx3pgFQOkos6tBoENXnfmqv6ijbr8CAgDKqj9mP/2RoS5sJuFZzWGgcwyUHwKBgQCOK0DWXl6hdzqlSi4Iva7aA8bB3ogxgxC61GTApHRrZ149V0noeeciD6Y4EIfKheJuUMVEzekTfUQDPdES8YUVdQYU2VXl8qXV3/qjqUAChrVJhXHxcnqSQlVLPMRCEy1ucxGtRrAc351p0wv1YiHME8g3LfnkbGmDLmLQcmgGcQKBgQCYU31KuO9Et5fnr+ymkmf618AzltN7Flb9vyHaZ7LtXnZYnWuaRjJYW7DdXyMIJh1K+CD0osgTLiaunUpONQUwdWZV/dMxvjiYshs6Ax8Fcel+rg2LLAuhiBmZI5XnDsXU70YEUeYIs6+UZZrPs/ncYcnotFGc8oN6AmYdjTdgjwKBgQCdqEp99qzqB8H+/lxpHar2K6bc6Ezmw44sOrlzvBPwg4MZFsNpje8SsEneIeDgZ03DhdaeiD4OkD4mr9JXUYsdiCRgIuDAV2/QsJJbHetchnU3SfT5g76Yc9iuAZNoTNTRdyJlemNQGBuRnIacvxuCPRh2Zr40710Ad82Q1x49qg==\n  alipayPublicKey: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAuYvIn8dC0AR299bvCnhV1on73/aSwGbm3PMxlc8AjmdWlT94g/4Mb6Oyc2Mf0lZj6N4o//w2z2pdUrXXlctLkaHoRjd3VMTYL+5gNc9iBueJt+/+TSjPMiU274csDJZhLrwVMuwccv1GdzvT3TQq1o709qrcZMMo+rELDcOHJmX7ikYMzEEHMeRI6xPKSDNswdYMSsutgIqxvJKs3chQPgMWvsBzgIHFfLolGtgTr4fi9zGuk2qSxBY0HfzTZyMACr8IXxw8lgNV3YB5djFLms5uY1qSlrvrODGWQgCsTxEGmNZAaZZQiboFaLPbZ/rsHFAGoy7qsAbYBmYoWwbmGwIDAQAB\n  notifyUrl: http://115.190.73.103/api/alipay/notify\n  returnUrl: http://115.190.73.103/idle\n  signType: RSA2\n  charset: UTF-8\n  # 我的支付宝网关地址\n  gatewayUrl: https://openapi-sandbox.dl.alipaydev.com/gateway.do\n\n', '01a44ab0c87abfaa114f676fe699157d', '2025-05-15 00:16:17', '2025-07-22 15:32:25', NULL, '221.0.131.144', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (24, 'hongshu-chat-dev.yml', 'DEFAULT_GROUP', 'spring:\n  # 缓存\n  redis:\n    open: true  # 是否开启redis缓存  true开启   false关闭\n    database: 0\n    host: 115.190.73.103\n    port: 6379\n    password: Myj950501  # 密码（默认为空）\n    timeout: 6000  # 连接超时时长（毫秒\n    lettuce:\n      pool:\n        max-active: 1000  # 连接池最大连接数（使用负值表示没有限制）\n        max-wait: -1      # 连接池最大阻塞等待时间（使用负值表示没有限制）\n        max-idle: 10      # 连接池中的最大空闲连接\n        min-idle: 5       # 连接池中的最小空闲连接\n  #指定数据源\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    #多数据源配置\n    dynamic:\n      primary: master\n      strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源\n      datasource:\n        # 数据库1\n        master:\n          driver-class-name: com.mysql.jdbc.Driver\n          url: jdbc:mysql://115.190.73.103:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8\n          username: root\n          password: Myj950501\n        # 数据库2\n        slave_1:\n          driver-class-name: com.mysql.jdbc.Driver\n          url: jdbc:mysql://115.190.73.103:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8\n          username: root\n          password: Myj950501\n      druid:\n        # 初始连接数\n        initialSize: 5\n        # 最小连接池数量\n        minIdle: 10\n        # 最大连接池数量\n        maxActive: 20\n        # 配置获取连接等待超时的时间\n        maxWait: 60000\n        # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒\n        timeBetweenEvictionRunsMillis: 60000\n        # 配置一个连接在池中最小生存的时间，单位是毫秒\n        minEvictableIdleTimeMillis: 300000\n        # 配置一个连接在池中最大生存的时间，单位是毫秒\n        maxEvictableIdleTimeMillis: 900000\n        # 配置检测连接是否有效\n        validationQuery: SELECT 1 FROM DUAL\n        testWhileIdle: true\n        testOnBorrow: false\n        testOnReturn: false\n        poolPreparedStatements: true\n        filters: stat,wall,slf4j,config\n        useGlobalDataSourceStat: true\n        stat:\n          log-slow-sql: true\n          merge-sql: true\n          slow-sql-millis: 10000\n# 系统配置参数\nsystem:\n  upload-path: /Users/mayongjian/Desktop/项目/Gitee/GPTHUB/upload/\nurl:\n  base:\n\n# 防止XSS攻击\nxss:\n  # 过滤开关\n  enabled: true\n  # 排除链接（多个用逗号分隔）\n  excludes: /notice\n  # 匹配链接\n  urlPatterns: /monitor/*,/tool/*', '195391b23df508c4994d53c16c9d6991', '2025-10-12 10:54:08', '2025-10-12 10:55:14', NULL, '221.3.19.207', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (25, 'nacos.cfg.dataIdfoo', 'foo', 'helloWorld', '1a833da63a6b7e20098dae06d06602e1', '2025-10-14 05:49:27', '2025-10-14 05:49:27', NULL, '194.102.39.128', '', '', NULL, NULL, NULL, 'text', NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------
DROP TABLE IF EXISTS `config_info_aggr`;
CREATE TABLE `config_info_aggr` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `datum_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'datum_id',
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '内容',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='增加租户字段';

-- ----------------------------
-- Records of config_info_aggr
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
DROP TABLE IF EXISTS `config_info_beta`;
CREATE TABLE `config_info_beta` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
  `beta_ips` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'betaIps',
  `md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
  `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
  `encrypted_data_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT '秘钥',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='config_info_beta';

-- ----------------------------
-- Records of config_info_beta
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
DROP TABLE IF EXISTS `config_info_tag`;
CREATE TABLE `config_info_tag` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
  `tag_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'tag_id',
  `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='config_info_tag';

-- ----------------------------
-- Records of config_info_tag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `config_tags_relation`;
CREATE TABLE `config_tags_relation` (
  `id` bigint NOT NULL COMMENT 'id',
  `tag_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'tag_name',
  `tag_type` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'tag_type',
  `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
  `nid` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`nid`),
  UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
  KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='config_tag_relation';

-- ----------------------------
-- Records of config_tags_relation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
DROP TABLE IF EXISTS `group_capacity`;
CREATE TABLE `group_capacity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
  `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数，，0表示使用默认值',
  `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='集群、各Group容量信息表';

-- ----------------------------
-- Records of group_capacity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
DROP TABLE IF EXISTS `his_config_info`;
CREATE TABLE `his_config_info` (
  `id` bigint unsigned NOT NULL,
  `nid` bigint unsigned NOT NULL AUTO_INCREMENT,
  `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `op_type` char(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
  `encrypted_data_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT '秘钥',
  PRIMARY KEY (`nid`),
  KEY `idx_gmt_create` (`gmt_create`),
  KEY `idx_gmt_modified` (`gmt_modified`),
  KEY `idx_did` (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='多租户改造';

-- ----------------------------
-- Records of his_config_info
-- ----------------------------
BEGIN;
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (23, 59, 'nacos.cfg.dataIdfoo', 'foo', '', 'helloWorld', '1a833da63a6b7e20098dae06d06602e1', '2025-09-23 15:35:14', '2025-09-23 07:35:15', NULL, '194.102.39.128', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (23, 60, 'nacos.cfg.dataIdfoo', 'foo', '', 'helloWorld', '1a833da63a6b7e20098dae06d06602e1', '2025-09-27 15:44:51', '2025-09-27 07:44:52', NULL, '194.102.39.128', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (23, 61, 'nacos.cfg.dataIdfoo', 'foo', '', 'helloWorld', '1a833da63a6b7e20098dae06d06602e1', '2025-10-01 15:41:41', '2025-10-01 07:41:41', NULL, '194.102.39.128', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (11, 62, 'hongshu-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  redis:\n    host: 115.190.73.103\n    port: 6379\n    password: Myj950501\n  cloud:\n    gateway:\n      discovery:\n        locator:\n          lowerCaseServiceId: true\n          enabled: true\n      routes:\n        # 认证中心\n        - id: hongshu-auth\n          uri: lb://hongshu-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            # 验证码处理\n            - CacheRequestFilter\n            - ValidateCodeFilter\n            - StripPrefix=1\n        # 代码生成\n        - id: hongshu-gen\n          uri: lb://hongshu-gen\n          predicates:\n            - Path=/code/**\n          filters:\n            - StripPrefix=1\n        # 定时任务\n        - id: hongshu-job\n          uri: lb://hongshu-job\n          predicates:\n            - Path=/schedule/**\n          filters:\n            - StripPrefix=1\n        # 系统模块\n        - id: hongshu-system\n          uri: lb://hongshu-system\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n        # 文件服务\n        - id: hongshu-file\n          uri: lb://hongshu-file\n          predicates:\n            - Path=/file/**\n          filters:\n            - StripPrefix=1\n        # 静态资源：本地文件访问\n        - id: hongshu-file-static\n          uri: lb://hongshu-file\n          predicates:\n            - Path=/profile/**\n        # web服务\n        - id: hongshu-web\n          uri: lb://hongshu-web\n          predicates:\n            - Path=/web/**\n          filters:\n            - StripPrefix=1\n        # idle服务\n        - id: hongshu-idle\n          uri: lb://hongshu-idle\n          predicates:\n            - Path=/idle/**\n          filters:\n            - StripPrefix=1\n\n\n# 安全配置\nsecurity:\n  # 验证码\n  captcha:\n    enabled: true\n    type: math\n  # 防止XSS攻击\n  xss:\n    enabled: true\n    excludeUrls:\n      - /system/notice\n  # 不校验白名单\n  ignore:\n    whites:\n      - /auth/logout\n      - /auth/login\n      - /auth/register\n      - /*/v2/api-docs\n      - /csrf\n      - /web/**\n      - /idle/**\n      - /*/v2/api-docs\n      - /*/v3/api-docs\n\n# springdoc配置\nspringdoc:\n  webjars:\n    # 访问前缀\n    prefix:\n', '947ac83f44201c3c5be456f79ab07d8c', '2025-10-12 10:53:24', '2025-10-12 02:53:25', NULL, '221.3.19.207', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (11, 63, 'hongshu-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  redis:\n    host: 115.190.73.103\n    port: 6379\n    password: Myj950501\n  cloud:\n    gateway:\n      discovery:\n        locator:\n          lowerCaseServiceId: true\n          enabled: true\n      routes:\n        # 认证中心\n        - id: hongshu-auth\n          uri: lb://hongshu-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            # 验证码处理\n            - CacheRequestFilter\n            - ValidateCodeFilter\n            - StripPrefix=1\n        # 代码生成\n        - id: hongshu-gen\n          uri: lb://hongshu-gen\n          predicates:\n            - Path=/code/**\n          filters:\n            - StripPrefix=1\n        # 定时任务\n        - id: hongshu-job\n          uri: lb://hongshu-job\n          predicates:\n            - Path=/schedule/**\n          filters:\n            - StripPrefix=1\n        # 系统模块\n        - id: hongshu-system\n          uri: lb://hongshu-system\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n        # 文件服务\n        - id: hongshu-file\n          uri: lb://hongshu-file\n          predicates:\n            - Path=/file/**\n          filters:\n            - StripPrefix=1\n        # 静态资源：本地文件访问\n        - id: hongshu-file-static\n          uri: lb://hongshu-file\n          predicates:\n            - Path=/profile/**\n        # web服务\n        - id: hongshu-web\n          uri: lb://hongshu-web\n          predicates:\n            - Path=/web/**\n          filters:\n            - StripPrefix=1\n        # idle服务\n        - id: hongshu-idle\n          uri: lb://hongshu-idle\n          predicates:\n            - Path=/idle/**\n          filters:\n            - StripPrefix=1\n        # chat服务\n        - id: hongshu-chat\n          uri: lb://hongshu-chat\n          predicates:\n            - Path=/chat/**\n          filters:\n            - StripPrefix=1\n\n\n# 安全配置\nsecurity:\n  # 验证码\n  captcha:\n    enabled: true\n    type: math\n  # 防止XSS攻击\n  xss:\n    enabled: true\n    excludeUrls:\n      - /system/notice\n  # 不校验白名单\n  ignore:\n    whites:\n      - /auth/logout\n      - /auth/login\n      - /auth/register\n      - /*/v2/api-docs\n      - /csrf\n      - /web/**\n      - /idle/**\n      - /chat/**\n      - /*/v2/api-docs\n      - /*/v3/api-docs\n\n# springdoc配置\nspringdoc:\n  webjars:\n    # 访问前缀\n    prefix:\n', 'a4b3c2929ec49982137b215a71b7c1d3', '2025-10-12 10:53:53', '2025-10-12 02:53:53', NULL, '221.3.19.207', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 64, 'hongshu-chat-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  # 缓存\n  redis:\n    open: true  # 是否开启redis缓存  true开启   false关闭\n    database: 0\n    host: localhost\n    port: 6379\n    password: Myj950501  # 密码（默认为空）\n    timeout: 6000  # 连接超时时长（毫秒\n    lettuce:\n      pool:\n        max-active: 1000  # 连接池最大连接数（使用负值表示没有限制）\n        max-wait: -1      # 连接池最大阻塞等待时间（使用负值表示没有限制）\n        max-idle: 10      # 连接池中的最大空闲连接\n        min-idle: 5       # 连接池中的最小空闲连接\n  #指定数据源\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    #多数据源配置\n    dynamic:\n      primary: master\n      strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源\n      datasource:\n        # 数据库1\n        master:\n          driver-class-name: com.mysql.jdbc.Driver\n          url: jdbc:mysql://localhost:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8\n          username: root\n          password: Myj950501\n        # 数据库2\n        slave_1:\n          driver-class-name: com.mysql.jdbc.Driver\n          url: jdbc:mysql://localhost:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8\n          username: root\n          password: Myj950501\n      druid:\n        # 初始连接数\n        initialSize: 5\n        # 最小连接池数量\n        minIdle: 10\n        # 最大连接池数量\n        maxActive: 20\n        # 配置获取连接等待超时的时间\n        maxWait: 60000\n        # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒\n        timeBetweenEvictionRunsMillis: 60000\n        # 配置一个连接在池中最小生存的时间，单位是毫秒\n        minEvictableIdleTimeMillis: 300000\n        # 配置一个连接在池中最大生存的时间，单位是毫秒\n        maxEvictableIdleTimeMillis: 900000\n        # 配置检测连接是否有效\n        validationQuery: SELECT 1 FROM DUAL\n        testWhileIdle: true\n        testOnBorrow: false\n        testOnReturn: false\n        poolPreparedStatements: true\n        filters: stat,wall,slf4j,config\n        useGlobalDataSourceStat: true\n        stat:\n          log-slow-sql: true\n          merge-sql: true\n          slow-sql-millis: 10000\n# 系统配置参数\nsystem:\n  upload-path: /Users/mayongjian/Desktop/项目/Gitee/GPTHUB/upload/\nurl:\n  base:\n\n# 防止XSS攻击\nxss:\n  # 过滤开关\n  enabled: true\n  # 排除链接（多个用逗号分隔）\n  excludes: /notice\n  # 匹配链接\n  urlPatterns: /monitor/*,/tool/*', '7f8b9afda5b680446545fd170819e1db', '2025-10-12 10:54:08', '2025-10-12 02:54:08', '', '221.3.19.207', 'I', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (23, 65, 'nacos.cfg.dataIdfoo', 'foo', '', 'helloWorld', '1a833da63a6b7e20098dae06d06602e1', '2025-10-12 10:54:34', '2025-10-12 02:54:34', NULL, '221.3.19.207', 'D', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (24, 66, 'hongshu-chat-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  # 缓存\n  redis:\n    open: true  # 是否开启redis缓存  true开启   false关闭\n    database: 0\n    host: localhost\n    port: 6379\n    password: Myj950501  # 密码（默认为空）\n    timeout: 6000  # 连接超时时长（毫秒\n    lettuce:\n      pool:\n        max-active: 1000  # 连接池最大连接数（使用负值表示没有限制）\n        max-wait: -1      # 连接池最大阻塞等待时间（使用负值表示没有限制）\n        max-idle: 10      # 连接池中的最大空闲连接\n        min-idle: 5       # 连接池中的最小空闲连接\n  #指定数据源\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    #多数据源配置\n    dynamic:\n      primary: master\n      strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源\n      datasource:\n        # 数据库1\n        master:\n          driver-class-name: com.mysql.jdbc.Driver\n          url: jdbc:mysql://localhost:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8\n          username: root\n          password: Myj950501\n        # 数据库2\n        slave_1:\n          driver-class-name: com.mysql.jdbc.Driver\n          url: jdbc:mysql://localhost:3306/hongshu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8\n          username: root\n          password: Myj950501\n      druid:\n        # 初始连接数\n        initialSize: 5\n        # 最小连接池数量\n        minIdle: 10\n        # 最大连接池数量\n        maxActive: 20\n        # 配置获取连接等待超时的时间\n        maxWait: 60000\n        # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒\n        timeBetweenEvictionRunsMillis: 60000\n        # 配置一个连接在池中最小生存的时间，单位是毫秒\n        minEvictableIdleTimeMillis: 300000\n        # 配置一个连接在池中最大生存的时间，单位是毫秒\n        maxEvictableIdleTimeMillis: 900000\n        # 配置检测连接是否有效\n        validationQuery: SELECT 1 FROM DUAL\n        testWhileIdle: true\n        testOnBorrow: false\n        testOnReturn: false\n        poolPreparedStatements: true\n        filters: stat,wall,slf4j,config\n        useGlobalDataSourceStat: true\n        stat:\n          log-slow-sql: true\n          merge-sql: true\n          slow-sql-millis: 10000\n# 系统配置参数\nsystem:\n  upload-path: /Users/mayongjian/Desktop/项目/Gitee/GPTHUB/upload/\nurl:\n  base:\n\n# 防止XSS攻击\nxss:\n  # 过滤开关\n  enabled: true\n  # 排除链接（多个用逗号分隔）\n  excludes: /notice\n  # 匹配链接\n  urlPatterns: /monitor/*,/tool/*', '7f8b9afda5b680446545fd170819e1db', '2025-10-12 10:55:14', '2025-10-12 02:55:14', NULL, '221.3.19.207', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 67, 'nacos.cfg.dataIdfoo', 'foo', '', 'helloWorld', '1a833da63a6b7e20098dae06d06602e1', '2025-10-14 05:49:27', '2025-10-13 21:49:27', NULL, '194.102.39.128', 'I', '', '');
COMMIT;

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  UNIQUE KEY `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  UNIQUE KEY `idx_user_role` (`username`,`role`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of roles
-- ----------------------------
BEGIN;
INSERT INTO `roles` (`username`, `role`) VALUES ('nacos', 'ROLE_ADMIN');
COMMIT;

-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
DROP TABLE IF EXISTS `tenant_capacity`;
CREATE TABLE `tenant_capacity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
  `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='租户容量信息表';

-- ----------------------------
-- Records of tenant_capacity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tenant_info
-- ----------------------------
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `kp` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'kp',
  `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
  `tenant_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_name',
  `tenant_desc` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'tenant_desc',
  `create_source` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'create_source',
  `gmt_create` bigint NOT NULL COMMENT '创建时间',
  `gmt_modified` bigint NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
  KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='tenant_info';

-- ----------------------------
-- Records of tenant_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('2tWP61hsKAZmHTmCHilN80VNpsC', '$2a$10$YcYl6MZ4ZDnNyEGiloRiUuqQfZ8PDgP3X5AQMQTnZSyS9Ji72kZB6', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('k1xa51lp', '$2a$10$HJO/F8YfPZ.Sg6UYvz5nq.YtgUZ/LiE61g/O.n3Tnxcw76.4WWbvm', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('k1xa51lp13', '$2a$10$k53/kr6.jPGA1hdre6WgNOqpnih.EH5DCycswteeaGtMxIrWvqsCy', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('k1xa51lp3', '$2a$10$XKMU.VG797p.RvgOKjRpCOXfHl5HmgoTD2S1u/fwDyegNsRr5RaFu', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('nacos1', '$2a$10$CTRlxiqnVns1hO7nTlo/R.kgXo4i4t6hguSsv.Xp4A2F0BUIvKoFW', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('nacos9991', '$2a$10$3AeO0Hh4QEpnl4ZdiS1ixO7zJlAGAIGnih9XC6vtv3gyA6bL6is3G', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('nacosnb123', '$2a$10$40z7O81cYZNQbkJXIbucQ.M3pKGI6v0tju7.9cG/Q1KGotEEJc33y', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('test_i63fuc6v', '$2a$10$zLV0cceidIIvUDCTfV.LzOwkvX7b.PqzJY3wcUYng4u7.0xGP9uGO', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('test_jeQv8B4O', '$2a$10$047tT.aOyPwDe2J2Q95p6.zn570J3HR4NUi7EcvHsJXQ7iw5IqxXm', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('test_kfzi1kly', '$2a$10$XVF.jsXNZ2VEiQwuvVa8CuArmkSgez0nkE0lLQBMVR7n6vM3cAgTm', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('test_mvosG8dq', '$2a$10$.4KuxCUPFmKmf8WQ4Tv.y.JEKAYCq9o2zhveL.8ZDGZgxDJRpxyC2', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('test_user_1755158856', '$2a$10$gHJ6E20JfLAUZBZtwtwlkOHPVnZbvqWRyVIeVw0SG3D4xu7nfPOo.', 1);
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('ZWMADT', '$2a$10$4oApexiDVl0w6T7BdrFrg.xDCQLFOA95AaDvR4dVCm6pnTahAih1m', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
